Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 16747 |
| Missing cells | 5824 |
| Missing cells (%) | 2.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.2 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Text | 3 |
| Categorical | 2 |
| DateTime | 1 |
last_review has 2905 (17.3%) missing values | Missing |
reviews_per_month has 2905 (17.3%) missing values | Missing |
id has unique values | Unique |
number_of_reviews has 2905 (17.3%) zeros | Zeros |
availability_365 has 6635 (39.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-25 09:23:31.205186 |
|---|---|
| Analysis finished | 2025-04-25 09:23:47.935220 |
| Duration | 16.73 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
Unique 
| Distinct | 16747 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18733164 |
| Minimum | 2539 |
|---|---|
| Maximum | 36485609 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 2539 |
|---|---|
| 5-th percentile | 1224161.5 |
| Q1 | 9287529.5 |
| median | 19317834 |
| Q3 | 28616560 |
| 95-th percentile | 35234760 |
| Maximum | 36485609 |
| Range | 36483070 |
| Interquartile range (IQR) | 19329031 |
Descriptive statistics
| Standard deviation | 10903901 |
|---|---|
| Coefficient of variation (CV) | 0.58206407 |
| Kurtosis | -1.2113291 |
| Mean | 18733164 |
| Median Absolute Deviation (MAD) | 9719442 |
| Skewness | -0.054980643 |
| Sum | 3.1372429 × 1011 |
| Variance | 1.1889507 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9138664 | 1 | < 0.1% |
| 7885044 | 1 | < 0.1% |
| 20802860 | 1 | < 0.1% |
| 19387402 | 1 | < 0.1% |
| 32195520 | 1 | < 0.1% |
| 28978145 | 1 | < 0.1% |
| 28721018 | 1 | < 0.1% |
| 7308735 | 1 | < 0.1% |
| 35710560 | 1 | < 0.1% |
| 35084043 | 1 | < 0.1% |
| Other values (16737) | 16737 |
| Value | Count | Frequency (%) |
| 2539 | 1 | |
| 3831 | 1 | |
| 5022 | 1 | |
| 5203 | 1 | |
| 5238 | 1 | |
| 5803 | 1 | |
| 6848 | 1 | |
| 7750 | 1 | |
| 7801 | 1 | |
| 8024 | 1 |
| Value | Count | Frequency (%) |
| 36485609 | 1 | |
| 36485057 | 1 | |
| 36479723 | 1 | |
| 36478343 | 1 | |
| 36472171 | 1 | |
| 36471896 | 1 | |
| 36468880 | 1 | |
| 36458668 | 1 | |
| 36456829 | 1 | |
| 36455917 | 1 |
name
Text
| Distinct | 16566 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 261.7 KiB |
Length
| Max length | 179 |
|---|---|
| Median length | 56 |
| Mean length | 36.461051 |
| Min length | 1 |
Unique
| Unique | 16436 ? |
|---|---|
| Unique (%) | 98.2% |
Sample
| 1st row | Private Lg Room 15 min to Manhattan |
|---|---|
| 2nd row | TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC |
| 3rd row | Voted #1 Location Quintessential 1BR W Village Apt |
| 4th row | Spacious 1 bedroom apartment 15min from Manhattan |
| 5th row | Big beautiful bedroom in huge Bushwick apartment |
| Value | Count | Frequency (%) |
| in | 5955 | 5.9% |
| room | 3661 | 3.6% |
| bedroom | 2688 | 2.7% |
| private | 2639 | 2.6% |
| 2517 | 2.5% | |
| apartment | 2408 | 2.4% |
| cozy | 1872 | 1.9% |
| apt | 1535 | 1.5% |
| brooklyn | 1508 | 1.5% |
| the | 1393 | 1.4% |
| Other values (5970) | 74697 |
Most occurring characters
| Value | Count | Frequency (%) |
| 84700 | 13.9% | |
| o | 42375 | 6.9% |
| e | 42227 | 6.9% |
| t | 36161 | 5.9% |
| a | 35887 | 5.9% |
| r | 33798 | 5.5% |
| i | 32716 | 5.4% |
| n | 32344 | 5.3% |
| l | 17685 | 2.9% |
| m | 17316 | 2.8% |
| Other values (479) | 235149 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 610358 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 84700 | 13.9% | |
| o | 42375 | 6.9% |
| e | 42227 | 6.9% |
| t | 36161 | 5.9% |
| a | 35887 | 5.9% |
| r | 33798 | 5.5% |
| i | 32716 | 5.4% |
| n | 32344 | 5.3% |
| l | 17685 | 2.9% |
| m | 17316 | 2.8% |
| Other values (479) | 235149 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 610358 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 84700 | 13.9% | |
| o | 42375 | 6.9% |
| e | 42227 | 6.9% |
| t | 36161 | 5.9% |
| a | 35887 | 5.9% |
| r | 33798 | 5.5% |
| i | 32716 | 5.4% |
| n | 32344 | 5.3% |
| l | 17685 | 2.9% |
| m | 17316 | 2.8% |
| Other values (479) | 235149 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 610358 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 84700 | 13.9% | |
| o | 42375 | 6.9% |
| e | 42227 | 6.9% |
| t | 36161 | 5.9% |
| a | 35887 | 5.9% |
| r | 33798 | 5.5% |
| i | 32716 | 5.4% |
| n | 32344 | 5.3% |
| l | 17685 | 2.9% |
| m | 17316 | 2.8% |
| Other values (479) | 235149 |
host_id
Real number (ℝ)
| Distinct | 15004 |
|---|---|
| Distinct (%) | 89.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66001283 |
| Minimum | 2571 |
|---|---|
| Maximum | 2.7427328 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 2571 |
|---|---|
| 5-th percentile | 773241.8 |
| Q1 | 7748101 |
| median | 30523475 |
| Q3 | 1.019804 × 108 |
| 95-th percentile | 2.4064613 × 108 |
| Maximum | 2.7427328 × 108 |
| Range | 2.7427071 × 108 |
| Interquartile range (IQR) | 94232295 |
Descriptive statistics
| Standard deviation | 77701222 |
|---|---|
| Coefficient of variation (CV) | 1.1772684 |
| Kurtosis | 0.34747126 |
| Mean | 66001283 |
| Median Absolute Deviation (MAD) | 27039318 |
| Skewness | 1.2651272 |
| Sum | 1.1053235 × 1012 |
| Variance | 6.03748 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 219517861 | 63 | 0.4% |
| 119669058 | 17 | 0.1% |
| 190921808 | 14 | 0.1% |
| 417504 | 12 | 0.1% |
| 213781715 | 10 | 0.1% |
| 5144567 | 9 | 0.1% |
| 224414117 | 8 | < 0.1% |
| 252604696 | 8 | < 0.1% |
| 201015598 | 8 | < 0.1% |
| 211549023 | 7 | < 0.1% |
| Other values (14994) | 16591 |
| Value | Count | Frequency (%) |
| 2571 | 1 | < 0.1% |
| 2787 | 3 | |
| 3151 | 1 | < 0.1% |
| 3415 | 1 | < 0.1% |
| 3563 | 1 | < 0.1% |
| 3647 | 2 | |
| 4396 | 1 | < 0.1% |
| 4869 | 1 | < 0.1% |
| 5089 | 1 | < 0.1% |
| 6041 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 274273284 | 1 | |
| 274195458 | 1 | |
| 274103383 | 1 | |
| 273870123 | 1 | |
| 273841667 | 1 | |
| 273741577 | 1 | |
| 273656890 | 1 | |
| 273619304 | 1 | |
| 273613106 | 1 | |
| 273570019 | 1 |
host_name
Text
| Distinct | 5968 |
|---|---|
| Distinct (%) | 35.7% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 261.7 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 31 |
| Mean length | 6.0646953 |
| Min length | 1 |
Unique
| Unique | 3921 ? |
|---|---|
| Unique (%) | 23.4% |
Sample
| 1st row | Iris |
|---|---|
| 2nd row | Johlex |
| 3rd row | John |
| 4th row | Regan |
| 5th row | Megan |
| Value | Count | Frequency (%) |
| 342 | 1.8% | |
| and | 208 | 1.1% |
| michael | 151 | 0.8% |
| david | 150 | 0.8% |
| john | 121 | 0.7% |
| alex | 107 | 0.6% |
| maria | 99 | 0.5% |
| daniel | 90 | 0.5% |
| sarah | 87 | 0.5% |
| anna | 80 | 0.4% |
| Other values (5596) | 17067 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13092 | 12.9% |
| e | 9896 | 9.7% |
| i | 8409 | 8.3% |
| n | 8272 | 8.1% |
| r | 6041 | 6.0% |
| l | 5251 | 5.2% |
| o | 4246 | 4.2% |
| t | 3209 | 3.2% |
| s | 3186 | 3.1% |
| h | 3164 | 3.1% |
| Other values (124) | 36757 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 101523 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 13092 | 12.9% |
| e | 9896 | 9.7% |
| i | 8409 | 8.3% |
| n | 8272 | 8.1% |
| r | 6041 | 6.0% |
| l | 5251 | 5.2% |
| o | 4246 | 4.2% |
| t | 3209 | 3.2% |
| s | 3186 | 3.1% |
| h | 3164 | 3.1% |
| Other values (124) | 36757 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 101523 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 13092 | 12.9% |
| e | 9896 | 9.7% |
| i | 8409 | 8.3% |
| n | 8272 | 8.1% |
| r | 6041 | 6.0% |
| l | 5251 | 5.2% |
| o | 4246 | 4.2% |
| t | 3209 | 3.2% |
| s | 3186 | 3.1% |
| h | 3164 | 3.1% |
| Other values (124) | 36757 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 101523 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 13092 | 12.9% |
| e | 9896 | 9.7% |
| i | 8409 | 8.3% |
| n | 8272 | 8.1% |
| r | 6041 | 6.0% |
| l | 5251 | 5.2% |
| o | 4246 | 4.2% |
| t | 3209 | 3.2% |
| s | 3186 | 3.1% |
| h | 3164 | 3.1% |
| Other values (124) | 36757 |
neighbourhood_group
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 261.7 KiB |
| Brooklyn | |
|---|---|
| Manhattan | |
| Queens | |
| Bronx | 413 |
| Staten Island | 150 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.116797 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Queens |
|---|---|
| 2nd row | Manhattan |
| 3rd row | Manhattan |
| 4th row | Queens |
| 5th row | Brooklyn |
Common Values
| Value | Count | Frequency (%) |
| Brooklyn | 7334 | |
| Manhattan | 6715 | |
| Queens | 2135 | 12.7% |
| Bronx | 413 | 2.5% |
| Staten Island | 150 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 7334 | |
| manhattan | 6715 | |
| queens | 2135 | 12.6% |
| bronx | 413 | 2.4% |
| staten | 150 | 0.9% |
| island | 150 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 23612 | |
| a | 20445 | |
| o | 15081 | |
| t | 13730 | |
| r | 7747 | 5.7% |
| B | 7747 | 5.7% |
| l | 7484 | 5.5% |
| y | 7334 | 5.4% |
| k | 7334 | 5.4% |
| M | 6715 | 4.9% |
| Other values (10) | 18703 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 135932 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 23612 | |
| a | 20445 | |
| o | 15081 | |
| t | 13730 | |
| r | 7747 | 5.7% |
| B | 7747 | 5.7% |
| l | 7484 | 5.5% |
| y | 7334 | 5.4% |
| k | 7334 | 5.4% |
| M | 6715 | 4.9% |
| Other values (10) | 18703 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 135932 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 23612 | |
| a | 20445 | |
| o | 15081 | |
| t | 13730 | |
| r | 7747 | 5.7% |
| B | 7747 | 5.7% |
| l | 7484 | 5.5% |
| y | 7334 | 5.4% |
| k | 7334 | 5.4% |
| M | 6715 | 4.9% |
| Other values (10) | 18703 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 135932 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 23612 | |
| a | 20445 | |
| o | 15081 | |
| t | 13730 | |
| r | 7747 | 5.7% |
| B | 7747 | 5.7% |
| l | 7484 | 5.5% |
| y | 7334 | 5.4% |
| k | 7334 | 5.4% |
| M | 6715 | 4.9% |
| Other values (10) | 18703 |
neighbourhood
Text
| Distinct | 215 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 261.7 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 17 |
| Mean length | 11.913358 |
| Min length | 4 |
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Sunnyside |
|---|---|
| 2nd row | Hell's Kitchen |
| 3rd row | West Village |
| 4th row | Astoria |
| 5th row | Bushwick |
| Value | Count | Frequency (%) |
| east | 2237 | 8.4% |
| side | 1432 | 5.3% |
| williamsburg | 1407 | 5.3% |
| harlem | 1385 | 5.2% |
| bedford-stuyvesant | 1343 | 5.0% |
| heights | 1320 | 4.9% |
| upper | 1116 | 4.2% |
| village | 1049 | 3.9% |
| bushwick | 880 | 3.3% |
| west | 856 | 3.2% |
| Other values (227) | 13760 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 18133 | 9.1% |
| i | 14026 | 7.0% |
| s | 13940 | 7.0% |
| a | 13151 | 6.6% |
| t | 13140 | 6.6% |
| l | 11714 | 5.9% |
| r | 11707 | 5.9% |
| 10038 | 5.0% | |
| n | 9039 | 4.5% |
| o | 8443 | 4.2% |
| Other values (44) | 76182 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 199513 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 18133 | 9.1% |
| i | 14026 | 7.0% |
| s | 13940 | 7.0% |
| a | 13151 | 6.6% |
| t | 13140 | 6.6% |
| l | 11714 | 5.9% |
| r | 11707 | 5.9% |
| 10038 | 5.0% | |
| n | 9039 | 4.5% |
| o | 8443 | 4.2% |
| Other values (44) | 76182 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 199513 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 18133 | 9.1% |
| i | 14026 | 7.0% |
| s | 13940 | 7.0% |
| a | 13151 | 6.6% |
| t | 13140 | 6.6% |
| l | 11714 | 5.9% |
| r | 11707 | 5.9% |
| 10038 | 5.0% | |
| n | 9039 | 4.5% |
| o | 8443 | 4.2% |
| Other values (44) | 76182 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 199513 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 18133 | 9.1% |
| i | 14026 | 7.0% |
| s | 13940 | 7.0% |
| a | 13151 | 6.6% |
| t | 13140 | 6.6% |
| l | 11714 | 5.9% |
| r | 11707 | 5.9% |
| 10038 | 5.0% | |
| n | 9039 | 4.5% |
| o | 8443 | 4.2% |
| Other values (44) | 76182 |
latitude
Real number (ℝ)
| Distinct | 11179 |
|---|---|
| Distinct (%) | 66.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.727028 |
| Minimum | 40.50873 |
|---|---|
| Maximum | 40.91306 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 40.50873 |
|---|---|
| 5-th percentile | 40.643146 |
| Q1 | 40.687595 |
| median | 40.72007 |
| Q3 | 40.76298 |
| 95-th percentile | 40.827477 |
| Maximum | 40.91306 |
| Range | 0.40433 |
| Interquartile range (IQR) | 0.075385 |
Descriptive statistics
| Standard deviation | 0.056214402 |
|---|---|
| Coefficient of variation (CV) | 0.0013802726 |
| Kurtosis | 0.035075335 |
| Mean | 40.727028 |
| Median Absolute Deviation (MAD) | 0.03631 |
| Skewness | 0.28256433 |
| Sum | 682055.54 |
| Variance | 0.003160059 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.68084 | 7 | < 0.1% |
| 40.71813 | 7 | < 0.1% |
| 40.68634 | 7 | < 0.1% |
| 40.68683 | 7 | < 0.1% |
| 40.72232 | 7 | < 0.1% |
| 40.69054 | 6 | < 0.1% |
| 40.77127 | 6 | < 0.1% |
| 40.72049 | 6 | < 0.1% |
| 40.72607 | 6 | < 0.1% |
| 40.68592 | 6 | < 0.1% |
| Other values (11169) | 16682 |
| Value | Count | Frequency (%) |
| 40.50873 | 1 | |
| 40.52293 | 1 | |
| 40.53871 | 1 | |
| 40.53939 | 1 | |
| 40.54106 | 1 | |
| 40.54312 | 1 | |
| 40.5455 | 1 | |
| 40.54889 | 1 | |
| 40.54901 | 1 | |
| 40.55182 | 1 |
| Value | Count | Frequency (%) |
| 40.91306 | 1 | |
| 40.90391 | 1 | |
| 40.90356 | 1 | |
| 40.90329 | 1 | |
| 40.90281 | 1 | |
| 40.9026 | 1 | |
| 40.89981 | 1 | |
| 40.89811 | 1 | |
| 40.89756 | 1 | |
| 40.89747 | 1 |
longitude
Real number (ℝ)
| Distinct | 9323 |
|---|---|
| Distinct (%) | 55.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.949359 |
| Minimum | -74.23914 |
|---|---|
| Maximum | -73.71795 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 16747 |
| Negative (%) | 100.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | -74.23914 |
|---|---|
| 5-th percentile | -74.00315 |
| Q1 | -73.98123 |
| median | -73.95365 |
| Q3 | -73.932665 |
| 95-th percentile | -73.855294 |
| Maximum | -73.71795 |
| Range | 0.52119 |
| Interquartile range (IQR) | 0.048565 |
Descriptive statistics
| Standard deviation | 0.047919729 |
|---|---|
| Coefficient of variation (CV) | -0.00064800737 |
| Kurtosis | 4.5825772 |
| Mean | -73.949359 |
| Median Absolute Deviation (MAD) | 0.02504 |
| Skewness | 1.2193676 |
| Sum | -1238429.9 |
| Variance | 0.0022963004 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.98589 | 9 | 0.1% |
| -73.94829 | 8 | < 0.1% |
| -73.95443 | 8 | < 0.1% |
| -73.95121 | 8 | < 0.1% |
| -73.95332 | 8 | < 0.1% |
| -73.95107 | 8 | < 0.1% |
| -73.95427 | 7 | < 0.1% |
| -73.95688 | 7 | < 0.1% |
| -73.95471 | 7 | < 0.1% |
| -73.95476 | 7 | < 0.1% |
| Other values (9313) | 16670 |
| Value | Count | Frequency (%) |
| -74.23914 | 1 | |
| -74.21238 | 1 | |
| -74.19626 | 1 | |
| -74.18259 | 1 | |
| -74.17388 | 1 | |
| -74.17117 | 1 | |
| -74.17065 | 1 | |
| -74.16966 | 1 | |
| -74.16634 | 1 | |
| -74.16558 | 1 |
| Value | Count | Frequency (%) |
| -73.71795 | 1 | |
| -73.71829 | 1 | |
| -73.72582 | 1 | |
| -73.72716 | 1 | |
| -73.72731 | 1 | |
| -73.7274 | 1 | |
| -73.72778 | 1 | |
| -73.72817 | 1 | |
| -73.72901 | 1 | |
| -73.72928 | 1 |
room_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 261.7 KiB |
| Private room | |
|---|---|
| Entire home/apt | |
| Shared room | 390 |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 13.417149 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private room |
|---|---|
| 2nd row | Entire home/apt |
| 3rd row | Entire home/apt |
| 4th row | Entire home/apt |
| 5th row | Private room |
Common Values
| Value | Count | Frequency (%) |
| Private room | 8316 | |
| Entire home/apt | 8041 | |
| Shared room | 390 | 2.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| room | 8706 | |
| private | 8316 | |
| entire | 8041 | |
| home/apt | 8041 | |
| shared | 390 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 25453 | |
| r | 25453 | |
| e | 24788 | |
| t | 24398 | |
| m | 16747 | |
| a | 16747 | |
| 16747 | ||
| i | 16357 | 7.3% |
| h | 8431 | 3.8% |
| P | 8316 | 3.7% |
| Other values (7) | 41260 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 224697 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 25453 | |
| r | 25453 | |
| e | 24788 | |
| t | 24398 | |
| m | 16747 | |
| a | 16747 | |
| 16747 | ||
| i | 16357 | 7.3% |
| h | 8431 | 3.8% |
| P | 8316 | 3.7% |
| Other values (7) | 41260 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 224697 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 25453 | |
| r | 25453 | |
| e | 24788 | |
| t | 24398 | |
| m | 16747 | |
| a | 16747 | |
| 16747 | ||
| i | 16357 | 7.3% |
| h | 8431 | 3.8% |
| P | 8316 | 3.7% |
| Other values (7) | 41260 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 224697 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 25453 | |
| r | 25453 | |
| e | 24788 | |
| t | 24398 | |
| m | 16747 | |
| a | 16747 | |
| 16747 | ||
| i | 16357 | 7.3% |
| h | 8431 | 3.8% |
| P | 8316 | 3.7% |
| Other values (7) | 41260 |
price
Real number (ℝ)
| Distinct | 302 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.08264 |
| Minimum | 10 |
|---|---|
| Maximum | 350 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 67 |
| median | 100 |
| Q3 | 159 |
| 95-th percentile | 265 |
| Maximum | 350 |
| Range | 340 |
| Interquartile range (IQR) | 92 |
Descriptive statistics
| Standard deviation | 70.664779 |
|---|---|
| Coefficient of variation (CV) | 0.58360784 |
| Kurtosis | 0.64243345 |
| Mean | 121.08264 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 1.0754008 |
| Sum | 2027771 |
| Variance | 4993.511 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 783 | 4.7% |
| 150 | 725 | 4.3% |
| 50 | 582 | 3.5% |
| 75 | 538 | 3.2% |
| 200 | 528 | 3.2% |
| 60 | 511 | 3.1% |
| 80 | 493 | 2.9% |
| 70 | 441 | 2.6% |
| 65 | 438 | 2.6% |
| 120 | 430 | 2.6% |
| Other values (292) | 11278 |
| Value | Count | Frequency (%) |
| 10 | 6 | |
| 11 | 2 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 3 | < 0.1% |
| 18 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 20 | 12 | |
| 21 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 350 | 132 | |
| 349 | 14 | 0.1% |
| 345 | 11 | 0.1% |
| 344 | 1 | < 0.1% |
| 342 | 1 | < 0.1% |
| 341 | 1 | < 0.1% |
| 340 | 8 | < 0.1% |
| 339 | 4 | < 0.1% |
| 336 | 1 | < 0.1% |
| 335 | 3 | < 0.1% |
minimum_nights
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.860572 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.291717 |
|---|---|
| Coefficient of variation (CV) | 0.80113941 |
| Kurtosis | 7.0373867 |
| Mean | 2.860572 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.3206945 |
| Sum | 47906 |
| Variance | 5.2519668 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 5003 | |
| 2 | 4619 | |
| 3 | 3086 | |
| 4 | 1253 | 7.5% |
| 5 | 1140 | 6.8% |
| 7 | 822 | 4.9% |
| 6 | 285 | 1.7% |
| 14 | 210 | 1.3% |
| 10 | 178 | 1.1% |
| 8 | 52 | 0.3% |
| Other values (4) | 99 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 5003 | |
| 2 | 4619 | |
| 3 | 3086 | |
| 4 | 1253 | 7.5% |
| 5 | 1140 | 6.8% |
| 6 | 285 | 1.7% |
| 7 | 822 | 4.9% |
| 8 | 52 | 0.3% |
| 9 | 34 | 0.2% |
| 10 | 178 | 1.1% |
| Value | Count | Frequency (%) |
| 14 | 210 | 1.3% |
| 13 | 20 | 0.1% |
| 12 | 34 | 0.2% |
| 11 | 11 | 0.1% |
| 10 | 178 | 1.1% |
| 9 | 34 | 0.2% |
| 8 | 52 | 0.3% |
| 7 | 822 | |
| 6 | 285 | 1.7% |
| 5 | 1140 |
number_of_reviews
Real number (ℝ)
Zeros 
| Distinct | 320 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.856392 |
| Minimum | 0 |
|---|---|
| Maximum | 607 |
| Zeros | 2905 |
| Zeros (%) | 17.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 27 |
| 95-th percentile | 123 |
| Maximum | 607 |
| Range | 607 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 47.30526 |
|---|---|
| Coefficient of variation (CV) | 1.8295383 |
| Kurtosis | 17.615739 |
| Mean | 25.856392 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 3.5194961 |
| Sum | 433017 |
| Variance | 2237.7876 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2905 | |
| 1 | 1718 | 10.3% |
| 2 | 1160 | 6.9% |
| 3 | 844 | 5.0% |
| 4 | 692 | 4.1% |
| 5 | 521 | 3.1% |
| 6 | 499 | 3.0% |
| 7 | 439 | 2.6% |
| 8 | 407 | 2.4% |
| 9 | 345 | 2.1% |
| Other values (310) | 7217 |
| Value | Count | Frequency (%) |
| 0 | 2905 | |
| 1 | 1718 | |
| 2 | 1160 | 6.9% |
| 3 | 844 | 5.0% |
| 4 | 692 | 4.1% |
| 5 | 521 | 3.1% |
| 6 | 499 | 3.0% |
| 7 | 439 | 2.6% |
| 8 | 407 | 2.4% |
| 9 | 345 | 2.1% |
| Value | Count | Frequency (%) |
| 607 | 1 | |
| 594 | 1 | |
| 510 | 1 | |
| 488 | 1 | |
| 474 | 1 | |
| 466 | 1 | |
| 459 | 1 | |
| 448 | 1 | |
| 441 | 1 | |
| 439 | 1 |
last_review
Date
Missing 
| Distinct | 1444 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 2905 |
| Missing (%) | 17.3% |
| Memory size | 261.7 KiB |
| Minimum | 2011-05-12 00:00:00 |
|---|---|
| Maximum | 2019-07-08 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
reviews_per_month
Real number (ℝ)
Missing 
| Distinct | 789 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 2905 |
| Missing (%) | 17.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4697789 |
| Minimum | 0.01 |
|---|---|
| Maximum | 27.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.04 |
| Q1 | 0.21 |
| median | 0.83 |
| Q3 | 2.18 |
| 95-th percentile | 4.8195 |
| Maximum | 27.95 |
| Range | 27.94 |
| Interquartile range (IQR) | 1.97 |
Descriptive statistics
| Standard deviation | 1.7342197 |
|---|---|
| Coefficient of variation (CV) | 1.1799187 |
| Kurtosis | 11.316384 |
| Mean | 1.4697789 |
| Median Absolute Deviation (MAD) | 0.72 |
| Skewness | 2.3434648 |
| Sum | 20344.68 |
| Variance | 3.007518 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.02 | 344 | 2.1% |
| 1 | 316 | 1.9% |
| 0.05 | 296 | 1.8% |
| 0.03 | 293 | 1.7% |
| 0.08 | 227 | 1.4% |
| 0.04 | 225 | 1.3% |
| 0.16 | 216 | 1.3% |
| 0.09 | 194 | 1.2% |
| 0.06 | 189 | 1.1% |
| 0.11 | 180 | 1.1% |
| Other values (779) | 11362 | |
| (Missing) | 2905 | 17.3% |
| Value | Count | Frequency (%) |
| 0.01 | 13 | 0.1% |
| 0.02 | 344 | |
| 0.03 | 293 | |
| 0.04 | 225 | |
| 0.05 | 296 | |
| 0.06 | 189 | |
| 0.07 | 135 | 0.8% |
| 0.08 | 227 | |
| 0.09 | 194 | |
| 0.1 | 155 |
| Value | Count | Frequency (%) |
| 27.95 | 1 | |
| 20.94 | 1 | |
| 19.75 | 1 | |
| 17.82 | 1 | |
| 16.22 | 1 | |
| 13.45 | 1 | |
| 13.42 | 1 | |
| 13.24 | 1 | |
| 13.15 | 1 | |
| 12.99 | 1 |
calculated_host_listings_count
Real number (ℝ)
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1051532 |
| Minimum | 1 |
|---|---|
| Maximum | 327 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 327 |
| Range | 326 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 20.105021 |
|---|---|
| Coefficient of variation (CV) | 6.4747276 |
| Kurtosis | 250.53754 |
| Mean | 3.1051532 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.751848 |
| Sum | 52002 |
| Variance | 404.21186 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 11762 | |
| 2 | 2397 | 14.3% |
| 3 | 1024 | 6.1% |
| 4 | 469 | 2.8% |
| 5 | 290 | 1.7% |
| 6 | 157 | 0.9% |
| 7 | 132 | 0.8% |
| 8 | 115 | 0.7% |
| 9 | 65 | 0.4% |
| 327 | 63 | 0.4% |
| Other values (15) | 273 | 1.6% |
| Value | Count | Frequency (%) |
| 1 | 11762 | |
| 2 | 2397 | 14.3% |
| 3 | 1024 | 6.1% |
| 4 | 469 | 2.8% |
| 5 | 290 | 1.7% |
| 6 | 157 | 0.9% |
| 7 | 132 | 0.8% |
| 8 | 115 | 0.7% |
| 9 | 65 | 0.4% |
| 10 | 51 | 0.3% |
| Value | Count | Frequency (%) |
| 327 | 63 | |
| 47 | 14 | 0.1% |
| 43 | 2 | < 0.1% |
| 34 | 17 | 0.1% |
| 33 | 10 | 0.1% |
| 30 | 8 | < 0.1% |
| 28 | 17 | 0.1% |
| 26 | 5 | < 0.1% |
| 20 | 8 | < 0.1% |
| 18 | 7 | < 0.1% |
availability_365
Real number (ℝ)
Zeros 
| Distinct | 366 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 97.520571 |
| Minimum | 0 |
|---|---|
| Maximum | 365 |
| Zeros | 6635 |
| Zeros (%) | 39.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 261.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 25 |
| Q3 | 179 |
| 95-th percentile | 353 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range (IQR) | 179 |
Descriptive statistics
| Standard deviation | 124.83891 |
|---|---|
| Coefficient of variation (CV) | 1.280129 |
| Kurtosis | -0.54187871 |
| Mean | 97.520571 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.9897628 |
| Sum | 1633177 |
| Variance | 15584.753 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6635 | |
| 365 | 300 | 1.8% |
| 1 | 149 | 0.9% |
| 364 | 132 | 0.8% |
| 5 | 124 | 0.7% |
| 3 | 107 | 0.6% |
| 6 | 105 | 0.6% |
| 2 | 104 | 0.6% |
| 179 | 102 | 0.6% |
| 4 | 102 | 0.6% |
| Other values (356) | 8887 |
| Value | Count | Frequency (%) |
| 0 | 6635 | |
| 1 | 149 | 0.9% |
| 2 | 104 | 0.6% |
| 3 | 107 | 0.6% |
| 4 | 102 | 0.6% |
| 5 | 124 | 0.7% |
| 6 | 105 | 0.6% |
| 7 | 87 | 0.5% |
| 8 | 82 | 0.5% |
| 9 | 81 | 0.5% |
| Value | Count | Frequency (%) |
| 365 | 300 | |
| 364 | 132 | |
| 363 | 74 | 0.4% |
| 362 | 57 | 0.3% |
| 361 | 36 | 0.2% |
| 360 | 27 | 0.2% |
| 359 | 48 | 0.3% |
| 358 | 43 | 0.3% |
| 357 | 24 | 0.1% |
| 356 | 23 | 0.1% |
Interactions
Missing values
Sample
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9138664 | Private Lg Room 15 min to Manhattan | 47594947 | Iris | Queens | Sunnyside | 40.74271 | -73.92493 | Private room | 74 | 2 | 6 | 2019-05-26 | 0.13 | 1 | 5 |
| 1 | 31444015 | TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC | 8523790 | Johlex | Manhattan | Hell's Kitchen | 40.76682 | -73.98878 | Entire home/apt | 170 | 3 | 0 | NaT | NaN | 1 | 188 |
| 2 | 8741020 | Voted #1 Location Quintessential 1BR W Village Apt | 45854238 | John | Manhattan | West Village | 40.73631 | -74.00611 | Entire home/apt | 245 | 3 | 51 | 2018-09-19 | 1.12 | 1 | 0 |
| 3 | 34602077 | Spacious 1 bedroom apartment 15min from Manhattan | 261055465 | Regan | Queens | Astoria | 40.76424 | -73.92351 | Entire home/apt | 125 | 3 | 1 | 2019-05-24 | 0.65 | 1 | 13 |
| 4 | 23203149 | Big beautiful bedroom in huge Bushwick apartment | 143460 | Megan | Brooklyn | Bushwick | 40.69839 | -73.92044 | Private room | 65 | 2 | 8 | 2019-06-23 | 0.52 | 2 | 8 |
| 5 | 4402805 | LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK | 22807362 | Jenny | Brooklyn | Prospect-Lefferts Gardens | 40.66025 | -73.96270 | Entire home/apt | 120 | 3 | 3 | 2018-08-28 | 0.05 | 1 | 16 |
| 6 | 30070126 | ✩Prime Renovated 1/1 Apartment in Upper East Side✩ | 4968673 | Sean | Manhattan | Upper East Side | 40.76831 | -73.95929 | Entire home/apt | 200 | 5 | 2 | 2019-05-26 | 0.68 | 1 | 71 |
| 7 | 34231172 | Fully renovated brick house floor in Brooklyn | 59642348 | Kevin | Brooklyn | Sunset Park | 40.64550 | -74.01262 | Entire home/apt | 95 | 1 | 9 | 2019-07-08 | 9.00 | 1 | 106 |
| 8 | 5856760 | Renovated 1BR in exciting, convenient area | 29408349 | Chad | Manhattan | Chinatown | 40.71490 | -73.99976 | Entire home/apt | 179 | 5 | 7 | 2017-04-18 | 0.14 | 1 | 0 |
| 9 | 7929441 | Beautiful Loft w/ Waterfront View! | 1453898 | Anthony | Brooklyn | Williamsburg | 40.71268 | -73.96676 | Private room | 105 | 2 | 232 | 2019-06-19 | 5.00 | 3 | 64 |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19990 | 5192459 | Quiet Room in 4BR UWS Brownstone | 10677483 | Greg | Manhattan | Upper West Side | 40.80173 | -73.96625 | Private room | 70 | 1 | 0 | NaT | NaN | 1 | 0 |
| 19991 | 1327940 | Huge Gorgeous Park View Apartment! | 3290436 | Hadar | Brooklyn | Flatbush | 40.65335 | -73.96257 | Entire home/apt | 120 | 3 | 13 | 2016-08-27 | 0.28 | 2 | 327 |
| 19992 | 23612681 | Shared Room 1 Stop from Manhattan on the F Train | 55724558 | Taylor | Queens | Long Island City | 40.76006 | -73.94080 | Private room | 55 | 4 | 2 | 2019-06-01 | 0.65 | 5 | 89 |
| 19993 | 34485745 | Midtown Manhattan Stunner - Private room | 261632622 | Royalton | Manhattan | Theater District | 40.75491 | -73.98507 | Private room | 100 | 1 | 3 | 2019-06-16 | 3.00 | 9 | 318 |
| 19994 | 25616250 | Stylish, spacious, private 1BR apt in Ditmas Park | 125396920 | Adam | Brooklyn | Flatbush | 40.64314 | -73.95705 | Entire home/apt | 75 | 3 | 10 | 2019-01-03 | 0.84 | 1 | 0 |
| 19995 | 7094539 | Tranquil haven in bubbly Brooklyn | 2052211 | Adriana | Brooklyn | Windsor Terrace | 40.65360 | -73.97546 | Entire home/apt | 143 | 14 | 2 | 2016-08-27 | 0.04 | 1 | 10 |
| 19996 | 4424261 | Large 1 BR with backyard on UWS | 3447311 | Sarah | Manhattan | Upper West Side | 40.80188 | -73.96808 | Entire home/apt | 200 | 2 | 22 | 2019-05-21 | 0.50 | 1 | 0 |
| 19997 | 4545882 | Amazing studio/Loft with a backyard | 23569951 | Kaveh | Manhattan | Upper East Side | 40.78110 | -73.94567 | Entire home/apt | 220 | 3 | 28 | 2019-05-23 | 0.50 | 1 | 293 |
| 19998 | 26518547 | U2 comfortable double bed sleeps 2 guests | 295128 | Carol Gloria | Bronx | Clason Point | 40.81225 | -73.85502 | Private room | 80 | 1 | 4 | 2019-07-01 | 1.48 | 7 | 365 |
| 19999 | 33631782 | Private Bedroom in Williamsburg Apt! | 8569221 | Andi | Brooklyn | Williamsburg | 40.71829 | -73.95819 | Private room | 109 | 3 | 3 | 2019-04-28 | 1.07 | 2 | 97 |